package com.example.springboot.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.springboot.domain.po.Grade;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * @Author：伐柯梦姝
 * @Package：com.example.springboot.dao
 * @Project：springboot
 * @name：GradeMapper
 * @Date：2025/2/7 20:41
 * @Filename：GradeMapper
 * @for:
 */
@Mapper
public interface GradeMapper extends BaseMapper<Grade> {
    @Select("select grade_name from grade where id = #{id}")
    public String selectGradeNameById(Integer id);

    @Select("select * from grade where grade_name like concat('%', #{name}, '%')")
    public Grade selectByGradeName(String name);
}
